﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ArtikelsDataSet" targetNamespace="http://tempuri.org/ArtikelsDataSet.xsd" xmlns:mstns="http://tempuri.org/ArtikelsDataSet.xsd" xmlns="http://tempuri.org/ArtikelsDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="fairshopConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="fairshopConnectionString (MySettings)" PropertyReference="ApplicationSettings.FairShop.My.MySettings.GlobalReference.Default.fairshopConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ArtikelsTableAdapter" GeneratorDataComponentClassName="ArtikelsTableAdapter" Name="Artikels" UserDataComponentName="ArtikelsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Artikels" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Artikels` WHERE ((`Id` = ?) AND ((? = 1 AND `Omschrijving` IS NULL) OR (`Omschrijving` = ?)) AND ((? = 1 AND `Artikelcode` IS NULL) OR (`Artikelcode` = ?)) AND ((? = 1 AND `Barcode` IS NULL) OR (`Barcode` = ?)) AND ((? = 1 AND `Verkoopbaar` IS NULL) OR (`Verkoopbaar` = ?)) AND ((? = 1 AND `Voorraad` IS NULL) OR (`Voorraad` = ?)) AND ((? = 1 AND `AantalPerVerpakking` IS NULL) OR (`AantalPerVerpakking` = ?)) AND ((? = 1 AND `Prijs` IS NULL) OR (`Prijs` = ?)) AND ((? = 1 AND `StatiegeldEuro` IS NULL) OR (`StatiegeldEuro` = ?)) AND ((? = 1 AND `Inkoopprijs` IS NULL) OR (`Inkoopprijs` = ?)) AND ((? = 1 AND `BTW` IS NULL) OR (`BTW` = ?)) AND ((? = 1 AND `IdLeverancier` IS NULL) OR (`IdLeverancier` = ?)) AND ((? = 1 AND `IsLeeggoed` IS NULL) OR (`IsLeeggoed` = ?)) AND ((? = 1 AND `IsCheque` IS NULL) OR (`IsCheque` = ?)) AND ((? = 1 AND `IdCategorie` IS NULL) OR (`IdCategorie` = ?)) AND ((? = 1 AND `VerwachteVoorraad` IS NULL) OR (`VerwachteVoorraad` = ?)) AND ((? = 1 AND `KortingLeverancier` IS NULL) OR (`KortingLeverancier` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Omschrijving" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Omschrijving" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Artikelcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Artikelcode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Artikelcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Artikelcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Barcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Barcode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Barcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Barcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Verkoopbaar" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Verkoopbaar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_Verkoopbaar" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Verkoopbaar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Voorraad" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Voorraad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Voorraad" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Voorraad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AantalPerVerpakking" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AantalPerVerpakking" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AantalPerVerpakking" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AantalPerVerpakking" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Prijs" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Prijs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Prijs" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Prijs" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_StatiegeldEuro" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StatiegeldEuro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_StatiegeldEuro" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="StatiegeldEuro" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Inkoopprijs" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Inkoopprijs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Inkoopprijs" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Inkoopprijs" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BTW" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BTW" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_BTW" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="BTW" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdLeverancier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLeverancier" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdLeverancier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLeverancier" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsLeeggoed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsLeeggoed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsLeeggoed" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsLeeggoed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsCheque" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsCheque" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsCheque" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsCheque" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdCategorie" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdCategorie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdCategorie" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdCategorie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VerwachteVoorraad" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VerwachteVoorraad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VerwachteVoorraad" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VerwachteVoorraad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_KortingLeverancier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="KortingLeverancier" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_KortingLeverancier" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="KortingLeverancier" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Artikels` (`Omschrijving`, `Artikelcode`, `Barcode`, `Verkoopbaar`, `Voorraad`, `AantalPerVerpakking`, `Prijs`, `StatiegeldEuro`, `Inkoopprijs`, `BTW`, `IdLeverancier`, `IsLeeggoed`, `IsCheque`, `IdCategorie`, `VerwachteVoorraad`, `KortingLeverancier`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Omschrijving" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Artikelcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Artikelcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Barcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Barcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Verkoopbaar" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Verkoopbaar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Voorraad" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Voorraad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AantalPerVerpakking" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AantalPerVerpakking" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Prijs" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Prijs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="StatiegeldEuro" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="StatiegeldEuro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Inkoopprijs" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Inkoopprijs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="BTW" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="BTW" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdLeverancier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLeverancier" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsLeeggoed" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsLeeggoed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsCheque" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsCheque" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdCategorie" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdCategorie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="VerwachteVoorraad" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VerwachteVoorraad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="KortingLeverancier" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="KortingLeverancier" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Omschrijving, Artikelcode, Barcode, Verkoopbaar, Voorraad, AantalPerVerpakking, Prijs, StatiegeldEuro, Inkoopprijs, BTW, IdLeverancier, IsLeeggoed, IsCheque, IdCategorie, VerwachteVoorraad, KortingLeverancier FROM Artikels</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Artikels` SET `Omschrijving` = ?, `Artikelcode` = ?, `Barcode` = ?, `Verkoopbaar` = ?, `Voorraad` = ?, `AantalPerVerpakking` = ?, `Prijs` = ?, `StatiegeldEuro` = ?, `Inkoopprijs` = ?, `BTW` = ?, `IdLeverancier` = ?, `IsLeeggoed` = ?, `IsCheque` = ?, `IdCategorie` = ?, `VerwachteVoorraad` = ?, `KortingLeverancier` = ? WHERE ((`Id` = ?) AND ((? = 1 AND `Omschrijving` IS NULL) OR (`Omschrijving` = ?)) AND ((? = 1 AND `Artikelcode` IS NULL) OR (`Artikelcode` = ?)) AND ((? = 1 AND `Barcode` IS NULL) OR (`Barcode` = ?)) AND ((? = 1 AND `Verkoopbaar` IS NULL) OR (`Verkoopbaar` = ?)) AND ((? = 1 AND `Voorraad` IS NULL) OR (`Voorraad` = ?)) AND ((? = 1 AND `AantalPerVerpakking` IS NULL) OR (`AantalPerVerpakking` = ?)) AND ((? = 1 AND `Prijs` IS NULL) OR (`Prijs` = ?)) AND ((? = 1 AND `StatiegeldEuro` IS NULL) OR (`StatiegeldEuro` = ?)) AND ((? = 1 AND `Inkoopprijs` IS NULL) OR (`Inkoopprijs` = ?)) AND ((? = 1 AND `BTW` IS NULL) OR (`BTW` = ?)) AND ((? = 1 AND `IdLeverancier` IS NULL) OR (`IdLeverancier` = ?)) AND ((? = 1 AND `IsLeeggoed` IS NULL) OR (`IsLeeggoed` = ?)) AND ((? = 1 AND `IsCheque` IS NULL) OR (`IsCheque` = ?)) AND ((? = 1 AND `IdCategorie` IS NULL) OR (`IdCategorie` = ?)) AND ((? = 1 AND `VerwachteVoorraad` IS NULL) OR (`VerwachteVoorraad` = ?)) AND ((? = 1 AND `KortingLeverancier` IS NULL) OR (`KortingLeverancier` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Omschrijving" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Artikelcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Artikelcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Barcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Barcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Verkoopbaar" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Verkoopbaar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Voorraad" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Voorraad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AantalPerVerpakking" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AantalPerVerpakking" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Prijs" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Prijs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="StatiegeldEuro" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="StatiegeldEuro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Inkoopprijs" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Inkoopprijs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="BTW" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="BTW" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdLeverancier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLeverancier" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsLeeggoed" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsLeeggoed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsCheque" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsCheque" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdCategorie" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdCategorie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="VerwachteVoorraad" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VerwachteVoorraad" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="KortingLeverancier" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="KortingLeverancier" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Omschrijving" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Omschrijving" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Artikelcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Artikelcode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Artikelcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Artikelcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Barcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Barcode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Barcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Barcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Verkoopbaar" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Verkoopbaar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_Verkoopbaar" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Verkoopbaar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Voorraad" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Voorraad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Voorraad" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Voorraad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AantalPerVerpakking" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AantalPerVerpakking" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AantalPerVerpakking" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AantalPerVerpakking" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Prijs" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Prijs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Prijs" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Prijs" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_StatiegeldEuro" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StatiegeldEuro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_StatiegeldEuro" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="StatiegeldEuro" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Inkoopprijs" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Inkoopprijs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Inkoopprijs" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Inkoopprijs" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BTW" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BTW" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_BTW" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="BTW" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdLeverancier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLeverancier" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdLeverancier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLeverancier" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsLeeggoed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsLeeggoed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsLeeggoed" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsLeeggoed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsCheque" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsCheque" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsCheque" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsCheque" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdCategorie" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdCategorie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdCategorie" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdCategorie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VerwachteVoorraad" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VerwachteVoorraad" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_VerwachteVoorraad" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VerwachteVoorraad" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_KortingLeverancier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="KortingLeverancier" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_KortingLeverancier" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="KortingLeverancier" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Omschrijving" DataSetColumn="Omschrijving" />
              <Mapping SourceColumn="Artikelcode" DataSetColumn="Artikelcode" />
              <Mapping SourceColumn="Barcode" DataSetColumn="Barcode" />
              <Mapping SourceColumn="Verkoopbaar" DataSetColumn="Verkoopbaar" />
              <Mapping SourceColumn="Voorraad" DataSetColumn="Voorraad" />
              <Mapping SourceColumn="AantalPerVerpakking" DataSetColumn="AantalPerVerpakking" />
              <Mapping SourceColumn="Prijs" DataSetColumn="Prijs" />
              <Mapping SourceColumn="StatiegeldEuro" DataSetColumn="StatiegeldEuro" />
              <Mapping SourceColumn="Inkoopprijs" DataSetColumn="Inkoopprijs" />
              <Mapping SourceColumn="BTW" DataSetColumn="BTW" />
              <Mapping SourceColumn="IdLeverancier" DataSetColumn="IdLeverancier" />
              <Mapping SourceColumn="IsLeeggoed" DataSetColumn="IsLeeggoed" />
              <Mapping SourceColumn="IsCheque" DataSetColumn="IsCheque" />
              <Mapping SourceColumn="IdCategorie" DataSetColumn="IdCategorie" />
              <Mapping SourceColumn="VerwachteVoorraad" DataSetColumn="VerwachteVoorraad" />
              <Mapping SourceColumn="KortingLeverancier" DataSetColumn="KortingLeverancier" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Artikels" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByBarcode" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByBarcode" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByBarcode">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AantalPerVerpakking, Artikelcode, BTW, Barcode, Id, IdCategorie, IdLeverancier, Inkoopprijs, IsCheque, IsLeeggoed, KortingLeverancier, Omschrijving, Prijs, StatiegeldEuro, Verkoopbaar, VerwachteVoorraad, Voorraad FROM Artikels WHERE (Barcode = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="Barcode" DataSourceName="Artikels" DataTypeServer="DbType.StringFixedLength(30)" DbType="String" Direction="Input" ParameterName="Barcode" Precision="0" ProviderType="WChar" Scale="0" Size="30" SourceColumn="Barcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Artikels" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillById">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AantalPerVerpakking, Artikelcode, BTW, Barcode, Id, IdCategorie, IdLeverancier, Inkoopprijs, IsCheque, IsLeeggoed, KortingLeverancier, Omschrijving, Prijs, StatiegeldEuro, Verkoopbaar, VerwachteVoorraad, Voorraad FROM Artikels WHERE (Id = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="Id" DataSourceName="Artikels" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LeveranciersTableAdapter" GeneratorDataComponentClassName="LeveranciersTableAdapter" Name="Leveranciers" UserDataComponentName="LeveranciersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Leveranciers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Leveranciers` WHERE ((`Id` = ?) AND ((? = 1 AND `Naam` IS NULL) OR (`Naam` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Naam" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Naam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Leveranciers` (`Naam`) VALUES (?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Naam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Naam FROM Leveranciers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Leveranciers` SET `Naam` = ? WHERE ((`Id` = ?) AND ((? = 1 AND `Naam` IS NULL) OR (`Naam` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Naam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Naam" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Naam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Naam" DataSetColumn="Naam" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CategorieenTableAdapter" GeneratorDataComponentClassName="CategorieenTableAdapter" Name="Categorieen" UserDataComponentName="CategorieenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Categorieen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Categorieen` WHERE ((`Id` = ?) AND ((? = 1 AND `Categorie` IS NULL) OR (`Categorie` = ?)) AND ((? = 1 AND `Subcategorie` IS NULL) OR (`Subcategorie` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Categorie" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Categorie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Categorie" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Categorie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Subcategorie" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Subcategorie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Subcategorie" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Subcategorie" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Categorieen` (`Categorie`, `Subcategorie`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Categorie" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Categorie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Subcategorie" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Subcategorie" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Id, Categorie, Subcategorie, Categorie &amp; ' - ' &amp; Subcategorie AS CategorieEnSubcategorie
FROM         Categorieen</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Categorieen` SET `Categorie` = ?, `Subcategorie` = ? WHERE ((`Id` = ?) AND ((? = 1 AND `Categorie` IS NULL) OR (`Categorie` = ?)) AND ((? = 1 AND `Subcategorie` IS NULL) OR (`Subcategorie` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Categorie" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Categorie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Subcategorie" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Subcategorie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Categorie" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Categorie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Categorie" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Categorie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Subcategorie" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Subcategorie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Subcategorie" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Subcategorie" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="CategorieEnSubcategorie" DataSetColumn="CategorieEnSubcategorie" />
              <Mapping SourceColumn="Categorie" DataSetColumn="Categorie" />
              <Mapping SourceColumn="Subcategorie" DataSetColumn="Subcategorie" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LeveringenTableAdapter" GeneratorDataComponentClassName="LeveringenTableAdapter" Name="Leveringen" UserDataComponentName="LeveringenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Leveringen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Leveringen` WHERE ((`Id` = ?) AND ((? = 1 AND `Datum` IS NULL) OR (`Datum` = ?)) AND ((? = 1 AND `IdLeverancier` IS NULL) OR (`IdLeverancier` = ?)) AND ((? = 1 AND `Factuurnummer` IS NULL) OR (`Factuurnummer` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Datum" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Datum" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdLeverancier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLeverancier" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdLeverancier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLeverancier" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Factuurnummer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Factuurnummer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Factuurnummer" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Factuurnummer" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Leveringen` (`Datum`, `IdLeverancier`, `Factuurnummer`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Datum" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdLeverancier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLeverancier" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Factuurnummer" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Factuurnummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Datum, IdLeverancier, Factuurnummer FROM Leveringen</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Leveringen` SET `Datum` = ?, `IdLeverancier` = ?, `Factuurnummer` = ? WHERE ((`Id` = ?) AND ((? = 1 AND `Datum` IS NULL) OR (`Datum` = ?)) AND ((? = 1 AND `IdLeverancier` IS NULL) OR (`IdLeverancier` = ?)) AND ((? = 1 AND `Factuurnummer` IS NULL) OR (`Factuurnummer` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Datum" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdLeverancier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLeverancier" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Factuurnummer" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Factuurnummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Datum" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Datum" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdLeverancier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLeverancier" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdLeverancier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLeverancier" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Factuurnummer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Factuurnummer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Factuurnummer" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Factuurnummer" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Datum" DataSetColumn="Datum" />
              <Mapping SourceColumn="IdLeverancier" DataSetColumn="IdLeverancier" />
              <Mapping SourceColumn="Factuurnummer" DataSetColumn="Factuurnummer" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Leveringen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillById">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Id, Datum, IdLeverancier, Factuurnummer FROM Leveringen WHERE Id = ?</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="Id" DataSourceName="Leveringen" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LeveringDetailsTableAdapter" GeneratorDataComponentClassName="LeveringDetailsTableAdapter" Name="LeveringDetails" UserDataComponentName="LeveringDetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="LeveringDetails" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `LeveringDetails` WHERE ((`Id` = ?) AND ((? = 1 AND `IdLevering` IS NULL) OR (`IdLevering` = ?)) AND ((? = 1 AND `IdArtikel` IS NULL) OR (`IdArtikel` = ?)) AND ((? = 1 AND `Aantal` IS NULL) OR (`Aantal` = ?)) AND ((? = 1 AND `Korting` IS NULL) OR (`Korting` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdLevering" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLevering" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdLevering" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLevering" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdArtikel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdArtikel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdArtikel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdArtikel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Aantal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Aantal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Aantal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Aantal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Korting" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Korting" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Korting" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Korting" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `LeveringDetails` (`IdLevering`, `IdArtikel`, `Aantal`, `Korting`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdLevering" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLevering" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdArtikel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdArtikel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Aantal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Aantal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Korting" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Korting" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Id, IdLevering, IdArtikel, Aantal, Korting
FROM         LeveringDetails</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `LeveringDetails` SET `IdLevering` = ?, `IdArtikel` = ?, `Aantal` = ?, `Korting` = ? WHERE ((`Id` = ?) AND ((? = 1 AND `IdLevering` IS NULL) OR (`IdLevering` = ?)) AND ((? = 1 AND `IdArtikel` IS NULL) OR (`IdArtikel` = ?)) AND ((? = 1 AND `Aantal` IS NULL) OR (`Aantal` = ?)) AND ((? = 1 AND `Korting` IS NULL) OR (`Korting` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdLevering" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLevering" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdArtikel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdArtikel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Aantal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Aantal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Korting" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Korting" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdLevering" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLevering" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdLevering" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLevering" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdArtikel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdArtikel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdArtikel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdArtikel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Aantal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Aantal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Aantal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Aantal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Korting" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Korting" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Korting" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Korting" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="IdLevering" DataSetColumn="IdLevering" />
              <Mapping SourceColumn="IdArtikel" DataSetColumn="IdArtikel" />
              <Mapping SourceColumn="Aantal" DataSetColumn="Aantal" />
              <Mapping SourceColumn="Korting" DataSetColumn="Korting" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="LeveringDetails" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdLevering" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByIdLevering" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByIdLevering">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Aantal, Id, IdArtikel, IdLevering, Korting
FROM         LeveringDetails
WHERE     (IdLevering = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="IdLevering" DataSourceName="LeveringDetails" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="IdLevering" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLevering" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VerkopenTableAdapter" GeneratorDataComponentClassName="VerkopenTableAdapter" Name="Verkopen" UserDataComponentName="VerkopenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Verkopen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Verkopen` WHERE ((`Id` = ?) AND ((? = 1 AND `Datum` IS NULL) OR (`Datum` = ?)) AND ((? = 1 AND `Tijd` IS NULL) OR (`Tijd` = ?)) AND ((? = 1 AND `IdKlant` IS NULL) OR (`IdKlant` = ?)) AND ((? = 1 AND `CashBetaald` IS NULL) OR (`CashBetaald` = ?)) AND ((? = 1 AND `IdWinkelier` IS NULL) OR (`IdWinkelier` = ?)) AND ((? = 1 AND `IdSoort` IS NULL) OR (`IdSoort` = ?)) AND ((? = 1 AND `Begintotaal` IS NULL) OR (`Begintotaal` = ?)) AND ((? = 1 AND `Eindtotaal` IS NULL) OR (`Eindtotaal` = ?)) AND ((? = 1 AND `InUitKasBedrag` IS NULL) OR (`InUitKasBedrag` = ?)) AND ((? = 1 AND `NaarBankBedrag` IS NULL) OR (`NaarBankBedrag` = ?)) AND ((? = 1 AND `NaarBankNaam` IS NULL) OR (`NaarBankNaam` = ?)) AND ((? = 1 AND `NaarBankReferentie` IS NULL) OR (`NaarBankReferentie` = ?)) AND ((? = 1 AND `FactuurNummer` IS NULL) OR (`FactuurNummer` = ?)) AND ((? = 1 AND `IsFactuurBehandeld` IS NULL) OR (`IsFactuurBehandeld` = ?)) AND ((? = 1 AND `Omschrijving` IS NULL) OR (`Omschrijving` = ?)) AND ((? = 1 AND `Kortingspercentage` IS NULL) OR (`Kortingspercentage` = ?)) AND ((? = 1 AND `Consignatie` IS NULL) OR (`Consignatie` = ?)) AND ((? = 1 AND `BedragBancontact` IS NULL) OR (`BedragBancontact` = ?)) AND ((? = 1 AND `BedragMaaltijdcheques` IS NULL) OR (`BedragMaaltijdcheques` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Datum" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Datum" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Tijd" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Tijd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Tijd" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Tijd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdKlant" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdKlant" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdKlant" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdKlant" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CashBetaald" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CashBetaald" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_CashBetaald" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="CashBetaald" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdWinkelier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdWinkelier" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdWinkelier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdWinkelier" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdSoort" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdSoort" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdSoort" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdSoort" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Begintotaal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Begintotaal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Begintotaal" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Begintotaal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Eindtotaal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Eindtotaal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Eindtotaal" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Eindtotaal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InUitKasBedrag" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InUitKasBedrag" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_InUitKasBedrag" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="InUitKasBedrag" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NaarBankBedrag" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NaarBankBedrag" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_NaarBankBedrag" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="NaarBankBedrag" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NaarBankNaam" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NaarBankNaam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NaarBankNaam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NaarBankNaam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NaarBankReferentie" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NaarBankReferentie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NaarBankReferentie" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NaarBankReferentie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FactuurNummer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FactuurNummer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_FactuurNummer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FactuurNummer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsFactuurBehandeld" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsFactuurBehandeld" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsFactuurBehandeld" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsFactuurBehandeld" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Omschrijving" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Omschrijving" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Kortingspercentage" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Kortingspercentage" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_Kortingspercentage" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="Kortingspercentage" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Consignatie" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Consignatie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_Consignatie" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Consignatie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BedragBancontact" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BedragBancontact" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_BedragBancontact" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="BedragBancontact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BedragMaaltijdcheques" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BedragMaaltijdcheques" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_BedragMaaltijdcheques" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="BedragMaaltijdcheques" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Verkopen` (`Datum`, `Tijd`, `IdKlant`, `CashBetaald`, `IdWinkelier`, `IdSoort`, `Begintotaal`, `Eindtotaal`, `CommentaarBegintotaal`, `CommentaarEindtotaal`, `InUitKasBedrag`, `InUitKasReden`, `NaarBankBedrag`, `NaarBankNaam`, `NaarBankReferentie`, `FactuurNummer`, `IsFactuurBehandeld`, `Omschrijving`, `Kortingspercentage`, `Consignatie`, `BedragBancontact`, `BedragMaaltijdcheques`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Datum" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Tijd" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Tijd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdKlant" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdKlant" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="CashBetaald" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="CashBetaald" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdWinkelier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdWinkelier" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdSoort" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdSoort" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Begintotaal" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Begintotaal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Eindtotaal" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Eindtotaal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CommentaarBegintotaal" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="CommentaarBegintotaal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CommentaarEindtotaal" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="CommentaarEindtotaal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="InUitKasBedrag" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="InUitKasBedrag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="InUitKasReden" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="InUitKasReden" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="NaarBankBedrag" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="NaarBankBedrag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NaarBankNaam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NaarBankNaam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NaarBankReferentie" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NaarBankReferentie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="FactuurNummer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FactuurNummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsFactuurBehandeld" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsFactuurBehandeld" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Omschrijving" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Kortingspercentage" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="Kortingspercentage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Consignatie" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Consignatie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="BedragBancontact" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="BedragBancontact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="BedragMaaltijdcheques" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="BedragMaaltijdcheques" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        Id, Datum, Tijd, IdKlant, CashBetaald, IdWinkelier, IdSoort, Begintotaal, Eindtotaal, CommentaarBegintotaal, CommentaarEindtotaal, InUitKasBedrag, InUitKasReden, NaarBankBedrag, NaarBankNaam, 
                         NaarBankReferentie, FactuurNummer, IsFactuurBehandeld, Omschrijving, Kortingspercentage, Consignatie, BedragBancontact, BedragMaaltijdcheques
FROM            Verkopen</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Verkopen` SET `Datum` = ?, `Tijd` = ?, `IdKlant` = ?, `CashBetaald` = ?, `IdWinkelier` = ?, `IdSoort` = ?, `Begintotaal` = ?, `Eindtotaal` = ?, `CommentaarBegintotaal` = ?, `CommentaarEindtotaal` = ?, `InUitKasBedrag` = ?, `InUitKasReden` = ?, `NaarBankBedrag` = ?, `NaarBankNaam` = ?, `NaarBankReferentie` = ?, `FactuurNummer` = ?, `IsFactuurBehandeld` = ?, `Omschrijving` = ?, `Kortingspercentage` = ?, `Consignatie` = ?, `BedragBancontact` = ?, `BedragMaaltijdcheques` = ? WHERE ((`Id` = ?) AND ((? = 1 AND `Datum` IS NULL) OR (`Datum` = ?)) AND ((? = 1 AND `Tijd` IS NULL) OR (`Tijd` = ?)) AND ((? = 1 AND `IdKlant` IS NULL) OR (`IdKlant` = ?)) AND ((? = 1 AND `CashBetaald` IS NULL) OR (`CashBetaald` = ?)) AND ((? = 1 AND `IdWinkelier` IS NULL) OR (`IdWinkelier` = ?)) AND ((? = 1 AND `IdSoort` IS NULL) OR (`IdSoort` = ?)) AND ((? = 1 AND `Begintotaal` IS NULL) OR (`Begintotaal` = ?)) AND ((? = 1 AND `Eindtotaal` IS NULL) OR (`Eindtotaal` = ?)) AND ((? = 1 AND `InUitKasBedrag` IS NULL) OR (`InUitKasBedrag` = ?)) AND ((? = 1 AND `NaarBankBedrag` IS NULL) OR (`NaarBankBedrag` = ?)) AND ((? = 1 AND `NaarBankNaam` IS NULL) OR (`NaarBankNaam` = ?)) AND ((? = 1 AND `NaarBankReferentie` IS NULL) OR (`NaarBankReferentie` = ?)) AND ((? = 1 AND `FactuurNummer` IS NULL) OR (`FactuurNummer` = ?)) AND ((? = 1 AND `IsFactuurBehandeld` IS NULL) OR (`IsFactuurBehandeld` = ?)) AND ((? = 1 AND `Omschrijving` IS NULL) OR (`Omschrijving` = ?)) AND ((? = 1 AND `Kortingspercentage` IS NULL) OR (`Kortingspercentage` = ?)) AND ((? = 1 AND `Consignatie` IS NULL) OR (`Consignatie` = ?)) AND ((? = 1 AND `BedragBancontact` IS NULL) OR (`BedragBancontact` = ?)) AND ((? = 1 AND `BedragMaaltijdcheques` IS NULL) OR (`BedragMaaltijdcheques` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Datum" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Tijd" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Tijd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdKlant" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdKlant" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="CashBetaald" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="CashBetaald" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdWinkelier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdWinkelier" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdSoort" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdSoort" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Begintotaal" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Begintotaal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Eindtotaal" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Eindtotaal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CommentaarBegintotaal" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="CommentaarBegintotaal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CommentaarEindtotaal" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="CommentaarEindtotaal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="InUitKasBedrag" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="InUitKasBedrag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="InUitKasReden" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="InUitKasReden" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="NaarBankBedrag" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="NaarBankBedrag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NaarBankNaam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NaarBankNaam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NaarBankReferentie" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NaarBankReferentie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="FactuurNummer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FactuurNummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsFactuurBehandeld" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsFactuurBehandeld" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Omschrijving" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Kortingspercentage" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="Kortingspercentage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Consignatie" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Consignatie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="BedragBancontact" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="BedragBancontact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="BedragMaaltijdcheques" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="BedragMaaltijdcheques" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Datum" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Datum" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Tijd" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Tijd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Tijd" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Tijd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdKlant" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdKlant" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdKlant" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdKlant" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CashBetaald" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CashBetaald" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_CashBetaald" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="CashBetaald" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdWinkelier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdWinkelier" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdWinkelier" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdWinkelier" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdSoort" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdSoort" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdSoort" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdSoort" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Begintotaal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Begintotaal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Begintotaal" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Begintotaal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Eindtotaal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Eindtotaal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Eindtotaal" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Eindtotaal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_InUitKasBedrag" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="InUitKasBedrag" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_InUitKasBedrag" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="InUitKasBedrag" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NaarBankBedrag" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NaarBankBedrag" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_NaarBankBedrag" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="NaarBankBedrag" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NaarBankNaam" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NaarBankNaam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NaarBankNaam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NaarBankNaam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NaarBankReferentie" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NaarBankReferentie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NaarBankReferentie" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NaarBankReferentie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FactuurNummer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FactuurNummer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_FactuurNummer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FactuurNummer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsFactuurBehandeld" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsFactuurBehandeld" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsFactuurBehandeld" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsFactuurBehandeld" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Omschrijving" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Omschrijving" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Kortingspercentage" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Kortingspercentage" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_Kortingspercentage" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="Kortingspercentage" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Consignatie" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Consignatie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_Consignatie" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Consignatie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BedragBancontact" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BedragBancontact" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_BedragBancontact" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="BedragBancontact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BedragMaaltijdcheques" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BedragMaaltijdcheques" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_BedragMaaltijdcheques" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="BedragMaaltijdcheques" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="IdKlant" DataSetColumn="IdKlant" />
              <Mapping SourceColumn="CashBetaald" DataSetColumn="CashBetaald" />
              <Mapping SourceColumn="IdWinkelier" DataSetColumn="IdWinkelier" />
              <Mapping SourceColumn="IdSoort" DataSetColumn="IdSoort" />
              <Mapping SourceColumn="Datum" DataSetColumn="Datum" />
              <Mapping SourceColumn="Tijd" DataSetColumn="Tijd" />
              <Mapping SourceColumn="Begintotaal" DataSetColumn="Begintotaal" />
              <Mapping SourceColumn="Eindtotaal" DataSetColumn="Eindtotaal" />
              <Mapping SourceColumn="CommentaarBegintotaal" DataSetColumn="CommentaarBegintotaal" />
              <Mapping SourceColumn="CommentaarEindtotaal" DataSetColumn="CommentaarEindtotaal" />
              <Mapping SourceColumn="InUitKasBedrag" DataSetColumn="InUitKasBedrag" />
              <Mapping SourceColumn="InUitKasReden" DataSetColumn="InUitKasReden" />
              <Mapping SourceColumn="NaarBankBedrag" DataSetColumn="NaarBankBedrag" />
              <Mapping SourceColumn="NaarBankNaam" DataSetColumn="NaarBankNaam" />
              <Mapping SourceColumn="NaarBankReferentie" DataSetColumn="NaarBankReferentie" />
              <Mapping SourceColumn="FactuurNummer" DataSetColumn="FactuurNummer" />
              <Mapping SourceColumn="IsFactuurBehandeld" DataSetColumn="IsFactuurBehandeld" />
              <Mapping SourceColumn="Omschrijving" DataSetColumn="Omschrijving" />
              <Mapping SourceColumn="Kortingspercentage" DataSetColumn="Kortingspercentage" />
              <Mapping SourceColumn="Consignatie" DataSetColumn="Consignatie" />
              <Mapping SourceColumn="BedragBancontact" DataSetColumn="BedragBancontact" />
              <Mapping SourceColumn="BedragMaaltijdcheques" DataSetColumn="BedragMaaltijdcheques" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Verkopen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDatum" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByDatum" GeneratorSourceName="FillByDatum" GetMethodModifier="Public" GetMethodName="GetDataByDatum" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByDatum" UserSourceName="FillByDatum">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT BedragBancontact, BedragMaaltijdcheques, Begintotaal, CashBetaald, CommentaarBegintotaal, CommentaarEindtotaal, Consignatie, Datum, Eindtotaal, FactuurNummer, Id, IdKlant, IdSoort, IdWinkelier, InUitKasBedrag, InUitKasReden, IsFactuurBehandeld, Kortingspercentage, NaarBankBedrag, NaarBankNaam, NaarBankReferentie, Omschrijving, Tijd FROM Verkopen ORDER BY Datum</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Verkopen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillById">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT BedragBancontact, BedragMaaltijdcheques, Begintotaal, CashBetaald, CommentaarBegintotaal, CommentaarEindtotaal, Consignatie, Datum, Eindtotaal, FactuurNummer, Id, IdKlant, IdSoort, IdWinkelier, InUitKasBedrag, InUitKasReden, IsFactuurBehandeld, Kortingspercentage, NaarBankBedrag, NaarBankNaam, NaarBankReferentie, Omschrijving, Tijd FROM Verkopen WHERE (Id = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="Id" DataSourceName="Verkopen" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VerkoopsDetailsTableAdapter" GeneratorDataComponentClassName="VerkoopsDetailsTableAdapter" Name="VerkoopsDetails" UserDataComponentName="VerkoopsDetailsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Fill" GenerateShortCommands="false" GeneratorSourceName="Fill" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        VerkoopsDetails.Id, VerkoopsDetails.IdVerkoop, VerkoopsDetails.VolgnummerKlant, VerkoopsDetails.IdArtikel, VerkoopsDetails.Prijs, VerkoopsDetails.StatiegeldEuro, VerkoopsDetails.Aantal, 
                         Artikels.Omschrijving, Artikels.Barcode, Artikels.BTW, VerkoopsDetails.ExtraOmschrijving, VerkoopsDetails.Bancontact, VerkoopsDetails.Maaltijdcheque
FROM            (VerkoopsDetails INNER JOIN
                         Artikels ON VerkoopsDetails.IdArtikel = Artikels.Id)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="IdVerkoop" DataSetColumn="IdVerkoop" />
              <Mapping SourceColumn="IdArtikel" DataSetColumn="IdArtikel" />
              <Mapping SourceColumn="Prijs" DataSetColumn="Prijs" />
              <Mapping SourceColumn="Aantal" DataSetColumn="Aantal" />
              <Mapping SourceColumn="Omschrijving" DataSetColumn="Omschrijving" />
              <Mapping SourceColumn="Barcode" DataSetColumn="Barcode" />
              <Mapping SourceColumn="BTW" DataSetColumn="BTW" />
              <Mapping SourceColumn="StatiegeldEuro" DataSetColumn="StatiegeldEuro" />
              <Mapping SourceColumn="VolgnummerKlant" DataSetColumn="VolgnummerKlant" />
              <Mapping SourceColumn="ExtraOmschrijving" DataSetColumn="ExtraOmschrijving" />
              <Mapping SourceColumn="Bancontact" DataSetColumn="Bancontact" />
              <Mapping SourceColumn="Maaltijdcheque" DataSetColumn="Maaltijdcheque" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByIdVerkoop" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByIdVerkoop" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByIdVerkoop">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        VerkoopsDetails.Id, VerkoopsDetails.IdVerkoop, VerkoopsDetails.VolgnummerKlant, VerkoopsDetails.IdArtikel, VerkoopsDetails.Prijs, VerkoopsDetails.StatiegeldEuro, VerkoopsDetails.Aantal, Artikels.Barcode, 
                         Artikels.BTW, VerkoopsDetails.ExtraOmschrijving, VerkoopsDetails.Bancontact, VerkoopsDetails.Maaltijdcheque
FROM            (VerkoopsDetails INNER JOIN
                         Artikels ON VerkoopsDetails.IdArtikel = Artikels.Id)
WHERE        (VerkoopsDetails.IdVerkoop = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="IdVerkoop" DataSourceName="VerkoopsDetails" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="IdVerkoop" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdVerkoop" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="KlantenTableAdapter" GeneratorDataComponentClassName="KlantenTableAdapter" Name="Klanten" UserDataComponentName="KlantenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Klanten" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Klanten` WHERE ((`Id` = ?) AND ((? = 1 AND `Naam` IS NULL) OR (`Naam` = ?)) AND ((? = 1 AND `Adres` IS NULL) OR (`Adres` = ?)) AND ((? = 1 AND `Postcode` IS NULL) OR (`Postcode` = ?)) AND ((? = 1 AND `Gemeente` IS NULL) OR (`Gemeente` = ?)) AND ((? = 1 AND `Telefoon` IS NULL) OR (`Telefoon` = ?)) AND ((? = 1 AND `Email` IS NULL) OR (`Email` = ?)) AND ((? = 1 AND `Klantenkaart` IS NULL) OR (`Klantenkaart` = ?)) AND ((? = 1 AND `BTWnummer` IS NULL) OR (`BTWnummer` = ?)) AND ((? = 1 AND `Fax` IS NULL) OR (`Fax` = ?)) AND ((? = 1 AND `GSM` IS NULL) OR (`GSM` = ?)) AND ((? = 1 AND `ContactPersoon` IS NULL) OR (`ContactPersoon` = ?)) AND ((? = 1 AND `TerAttentieVan` IS NULL) OR (`TerAttentieVan` = ?)) AND ((? = 1 AND `KortingsPercentage` IS NULL) OR (`KortingsPercentage` = ?)) AND ((? = 1 AND `BetaalConditieCode` IS NULL) OR (`BetaalConditieCode` = ?)) AND ((? = 1 AND `DatumVanVerwerking` IS NULL) OR (`DatumVanVerwerking` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Naam" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Naam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Adres" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Adres" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Adres" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Adres" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Postcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Postcode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Postcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Postcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Gemeente" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Gemeente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Gemeente" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Gemeente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Telefoon" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Telefoon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Telefoon" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Telefoon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Email" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Klantenkaart" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Klantenkaart" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_Klantenkaart" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Klantenkaart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BTWnummer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BTWnummer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_BTWnummer" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BTWnummer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fax" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Fax" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GSM" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GSM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GSM" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GSM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ContactPersoon" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ContactPersoon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ContactPersoon" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ContactPersoon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TerAttentieVan" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TerAttentieVan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TerAttentieVan" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TerAttentieVan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_KortingsPercentage" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="KortingsPercentage" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_KortingsPercentage" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="KortingsPercentage" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BetaalConditieCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BetaalConditieCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_BetaalConditieCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BetaalConditieCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DatumVanVerwerking" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DatumVanVerwerking" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_DatumVanVerwerking" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DatumVanVerwerking" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Klanten` (`Naam`, `Adres`, `Postcode`, `Gemeente`, `Telefoon`, `Email`, `Klantenkaart`, `BTWnummer`, `Fax`, `GSM`, `ContactPersoon`, `TerAttentieVan`, `KortingsPercentage`, `BetaalConditieCode`, `DatumVanVerwerking`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Naam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Adres" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Adres" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Postcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Postcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Gemeente" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Gemeente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Telefoon" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Telefoon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Klantenkaart" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Klantenkaart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BTWnummer" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BTWnummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Fax" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GSM" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GSM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ContactPersoon" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ContactPersoon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TerAttentieVan" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TerAttentieVan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="KortingsPercentage" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="KortingsPercentage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BetaalConditieCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BetaalConditieCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DatumVanVerwerking" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DatumVanVerwerking" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        Id, Naam, Adres, Postcode, Gemeente, Telefoon, Email, Klantenkaart, BTWnummer, Fax, GSM, ContactPersoon, TerAttentieVan, KortingsPercentage, BetaalConditieCode, DatumVanVerwerking
FROM            Klanten</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Klanten` SET `Naam` = ?, `Adres` = ?, `Postcode` = ?, `Gemeente` = ?, `Telefoon` = ?, `Email` = ?, `Klantenkaart` = ?, `BTWnummer` = ?, `Fax` = ?, `GSM` = ?, `ContactPersoon` = ?, `TerAttentieVan` = ?, `KortingsPercentage` = ?, `BetaalConditieCode` = ?, `DatumVanVerwerking` = ? WHERE ((`Id` = ?) AND ((? = 1 AND `Naam` IS NULL) OR (`Naam` = ?)) AND ((? = 1 AND `Adres` IS NULL) OR (`Adres` = ?)) AND ((? = 1 AND `Postcode` IS NULL) OR (`Postcode` = ?)) AND ((? = 1 AND `Gemeente` IS NULL) OR (`Gemeente` = ?)) AND ((? = 1 AND `Telefoon` IS NULL) OR (`Telefoon` = ?)) AND ((? = 1 AND `Email` IS NULL) OR (`Email` = ?)) AND ((? = 1 AND `Klantenkaart` IS NULL) OR (`Klantenkaart` = ?)) AND ((? = 1 AND `BTWnummer` IS NULL) OR (`BTWnummer` = ?)) AND ((? = 1 AND `Fax` IS NULL) OR (`Fax` = ?)) AND ((? = 1 AND `GSM` IS NULL) OR (`GSM` = ?)) AND ((? = 1 AND `ContactPersoon` IS NULL) OR (`ContactPersoon` = ?)) AND ((? = 1 AND `TerAttentieVan` IS NULL) OR (`TerAttentieVan` = ?)) AND ((? = 1 AND `KortingsPercentage` IS NULL) OR (`KortingsPercentage` = ?)) AND ((? = 1 AND `BetaalConditieCode` IS NULL) OR (`BetaalConditieCode` = ?)) AND ((? = 1 AND `DatumVanVerwerking` IS NULL) OR (`DatumVanVerwerking` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Naam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Adres" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Adres" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Postcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Postcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Gemeente" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Gemeente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Telefoon" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Telefoon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Klantenkaart" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Klantenkaart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BTWnummer" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BTWnummer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Fax" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GSM" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GSM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ContactPersoon" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ContactPersoon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TerAttentieVan" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TerAttentieVan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="KortingsPercentage" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="KortingsPercentage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="BetaalConditieCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BetaalConditieCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DatumVanVerwerking" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DatumVanVerwerking" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Naam" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Naam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Adres" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Adres" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Adres" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Adres" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Postcode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Postcode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Postcode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Postcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Gemeente" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Gemeente" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Gemeente" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Gemeente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Telefoon" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Telefoon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Telefoon" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Telefoon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Email" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Email" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Klantenkaart" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Klantenkaart" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_Klantenkaart" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Klantenkaart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BTWnummer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BTWnummer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_BTWnummer" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BTWnummer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Fax" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Fax" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GSM" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GSM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GSM" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GSM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ContactPersoon" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ContactPersoon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ContactPersoon" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ContactPersoon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TerAttentieVan" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TerAttentieVan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TerAttentieVan" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TerAttentieVan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_KortingsPercentage" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="KortingsPercentage" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="Original_KortingsPercentage" Precision="18" ProviderType="Numeric" Scale="0" Size="0" SourceColumn="KortingsPercentage" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BetaalConditieCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BetaalConditieCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_BetaalConditieCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="BetaalConditieCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DatumVanVerwerking" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DatumVanVerwerking" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_DatumVanVerwerking" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DatumVanVerwerking" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Naam" DataSetColumn="Naam" />
              <Mapping SourceColumn="Adres" DataSetColumn="Adres" />
              <Mapping SourceColumn="Postcode" DataSetColumn="Postcode" />
              <Mapping SourceColumn="Gemeente" DataSetColumn="Gemeente" />
              <Mapping SourceColumn="Telefoon" DataSetColumn="Telefoon" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Klantenkaart" DataSetColumn="Klantenkaart" />
              <Mapping SourceColumn="Fax" DataSetColumn="Fax" />
              <Mapping SourceColumn="GSM" DataSetColumn="GSM" />
              <Mapping SourceColumn="ContactPersoon" DataSetColumn="ContactPersoon" />
              <Mapping SourceColumn="TerAttentieVan" DataSetColumn="TerAttentieVan" />
              <Mapping SourceColumn="KortingsPercentage" DataSetColumn="KortingsPercentage" />
              <Mapping SourceColumn="BetaalConditieCode" DataSetColumn="BetaalConditieCode" />
              <Mapping SourceColumn="DatumVanVerwerking" DataSetColumn="DatumVanVerwerking" />
              <Mapping SourceColumn="BTWnummer" DataSetColumn="BTWnummer" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Klanten" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillById">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Adres, BTWnummer, BetaalConditieCode, ContactPersoon, DatumVanVerwerking, Email, Fax, GSM, Gemeente, Id, Klantenkaart, KortingsPercentage, Naam, Postcode, Telefoon, TerAttentieVan
FROM            Klanten
WHERE        (Id = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="Id" DataSourceName="Klanten" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WinkeliersTableAdapter" GeneratorDataComponentClassName="WinkeliersTableAdapter" Name="Winkeliers" UserDataComponentName="WinkeliersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Winkeliers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Winkeliers` WHERE ((`Id` = ?) AND ((? = 1 AND `Naam` IS NULL) OR (`Naam` = ?)) AND ((? = 1 AND `Wachtwoord` IS NULL) OR (`Wachtwoord` = ?)) AND ((? = 1 AND `IdLaatsteMelding` IS NULL) OR (`IdLaatsteMelding` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Naam" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Naam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Wachtwoord" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Wachtwoord" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Wachtwoord" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Wachtwoord" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdLaatsteMelding" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLaatsteMelding" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdLaatsteMelding" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLaatsteMelding" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Winkeliers` (`Naam`, `Wachtwoord`, `IdLaatsteMelding`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Naam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Wachtwoord" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Wachtwoord" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdLaatsteMelding" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLaatsteMelding" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Naam, Wachtwoord, IdLaatsteMelding FROM Winkeliers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Winkeliers` SET `Naam` = ?, `Wachtwoord` = ?, `IdLaatsteMelding` = ? WHERE ((`Id` = ?) AND ((? = 1 AND `Naam` IS NULL) OR (`Naam` = ?)) AND ((? = 1 AND `Wachtwoord` IS NULL) OR (`Wachtwoord` = ?)) AND ((? = 1 AND `IdLaatsteMelding` IS NULL) OR (`IdLaatsteMelding` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Naam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Wachtwoord" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Wachtwoord" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdLaatsteMelding" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLaatsteMelding" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Naam" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Naam" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Wachtwoord" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Wachtwoord" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Wachtwoord" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Wachtwoord" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdLaatsteMelding" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLaatsteMelding" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdLaatsteMelding" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdLaatsteMelding" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Naam" DataSetColumn="Naam" />
              <Mapping SourceColumn="Wachtwoord" DataSetColumn="Wachtwoord" />
              <Mapping SourceColumn="IdLaatsteMelding" DataSetColumn="IdLaatsteMelding" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Winkeliers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillById">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Id, IdLaatsteMelding, Naam, Wachtwoord FROM Winkeliers WHERE (Id = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="Id" DataSourceName="Winkeliers" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Winkeliers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByNaam" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByNaam" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillByNaam">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Id, IdLaatsteMelding, Naam, Wachtwoord FROM Winkeliers WHERE (Naam = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="Naam" DataSourceName="Winkeliers" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="Naam" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="Naam" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VerkoopsoortenTableAdapter" GeneratorDataComponentClassName="VerkoopsoortenTableAdapter" Name="Verkoopsoorten" UserDataComponentName="VerkoopsoortenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Verkoopsoorten" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Verkoopsoorten` WHERE ((`Id` = ?) AND ((? = 1 AND `Omschrijving` IS NULL) OR (`Omschrijving` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Omschrijving" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Omschrijving" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Verkoopsoorten` (`Omschrijving`) VALUES (?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Omschrijving" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Omschrijving FROM Verkoopsoorten</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Verkoopsoorten` SET `Omschrijving` = ? WHERE ((`Id` = ?) AND ((? = 1 AND `Omschrijving` IS NULL) OR (`Omschrijving` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Omschrijving" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Omschrijving" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Omschrijving" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Omschrijving" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Omschrijving" DataSetColumn="Omschrijving" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VoorraadbewegingenTableAdapter" GeneratorDataComponentClassName="VoorraadbewegingenTableAdapter" Name="Voorraadbewegingen" UserDataComponentName="VoorraadbewegingenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Voorraadbewegingen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Voorraadbewegingen` WHERE ((`Id` = ?) AND ((? = 1 AND `IdArtikel` IS NULL) OR (`IdArtikel` = ?)) AND ((? = 1 AND `Datum` IS NULL) OR (`Datum` = ?)) AND ((? = 1 AND `Aantal` IS NULL) OR (`Aantal` = ?)) AND ((? = 1 AND `Reden` IS NULL) OR (`Reden` = ?)) AND ((? = 1 AND `Inkoopprijs` IS NULL) OR (`Inkoopprijs` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdArtikel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdArtikel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdArtikel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdArtikel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Datum" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Datum" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Aantal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Aantal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Aantal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Aantal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Reden" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Reden" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Reden" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reden" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Inkoopprijs" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Inkoopprijs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Inkoopprijs" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Inkoopprijs" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Voorraadbewegingen` (`IdArtikel`, `Datum`, `Aantal`, `Reden`, `Inkoopprijs`) VALUES (?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdArtikel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdArtikel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Datum" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Aantal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Aantal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Reden" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reden" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Inkoopprijs" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Inkoopprijs" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT     Id, IdArtikel, Datum, Aantal, Reden, Inkoopprijs
FROM         Voorraadbewegingen</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Voorraadbewegingen` SET `IdArtikel` = ?, `Datum` = ?, `Aantal` = ?, `Reden` = ?, `Inkoopprijs` = ? WHERE ((`Id` = ?) AND ((? = 1 AND `IdArtikel` IS NULL) OR (`IdArtikel` = ?)) AND ((? = 1 AND `Datum` IS NULL) OR (`Datum` = ?)) AND ((? = 1 AND `Aantal` IS NULL) OR (`Aantal` = ?)) AND ((? = 1 AND `Reden` IS NULL) OR (`Reden` = ?)) AND ((? = 1 AND `Inkoopprijs` IS NULL) OR (`Inkoopprijs` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IdArtikel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdArtikel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Datum" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Aantal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Aantal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Reden" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reden" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Inkoopprijs" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Inkoopprijs" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IdArtikel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdArtikel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IdArtikel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IdArtikel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Datum" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Datum" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Datum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Aantal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Aantal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Aantal" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Aantal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Reden" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Reden" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Reden" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Reden" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Inkoopprijs" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Inkoopprijs" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="Original_Inkoopprijs" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="Inkoopprijs" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="IdArtikel" DataSetColumn="IdArtikel" />
              <Mapping SourceColumn="Datum" DataSetColumn="Datum" />
              <Mapping SourceColumn="Aantal" DataSetColumn="Aantal" />
              <Mapping SourceColumn="Reden" DataSetColumn="Reden" />
              <Mapping SourceColumn="Inkoopprijs" DataSetColumn="Inkoopprijs" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillWithArtikel" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillWithArtikel" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillWithArtikel">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Voorraadbewegingen.Id, Voorraadbewegingen.IdArtikel, Voorraadbewegingen.Datum, Voorraadbewegingen.Aantal, Voorraadbewegingen.Reden, 
                      Voorraadbewegingen.Inkoopprijs, Artikels.Omschrijving AS Artikel
FROM         (Voorraadbewegingen INNER JOIN
                      Artikels ON Artikels.Id = Voorraadbewegingen.IdArtikel)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MeldingenTableAdapter" GeneratorDataComponentClassName="MeldingenTableAdapter" Name="Meldingen" UserDataComponentName="MeldingenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="fairshopConnectionString (MySettings)" DbObjectName="Meldingen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Meldingen` WHERE ((`Id` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Meldingen` (`Melding`) VALUES (?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Melding" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Melding" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Melding FROM Meldingen</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Meldingen` SET `Melding` = ? WHERE ((`Id` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Melding" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Melding" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Melding" DataSetColumn="Melding" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ArtikelsDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ArtikelsDataSet" msprop:Generator_DataSetName="ArtikelsDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Artikels" msprop:Generator_UserTableName="Artikels" msprop:Generator_RowDeletedName="ArtikelsRowDeleted" msprop:Generator_RowChangedName="ArtikelsRowChanged" msprop:Generator_RowClassName="ArtikelsRow" msprop:Generator_RowChangingName="ArtikelsRowChanging" msprop:Generator_RowEvArgName="ArtikelsRowChangeEvent" msprop:Generator_RowEvHandlerName="ArtikelsRowChangeEventHandler" msprop:Generator_TableClassName="ArtikelsDataTable" msprop:Generator_TableVarName="tableArtikels" msprop:Generator_RowDeletingName="ArtikelsRowDeleting" msprop:Generator_TablePropName="Artikels">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Omschrijving" msprop:Generator_UserColumnName="Omschrijving" msprop:Generator_ColumnPropNameInRow="Omschrijving" msprop:Generator_ColumnVarNameInTable="columnOmschrijving" msprop:Generator_ColumnPropNameInTable="OmschrijvingColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Artikelcode" msprop:Generator_UserColumnName="Artikelcode" msprop:Generator_ColumnPropNameInRow="Artikelcode" msprop:Generator_ColumnVarNameInTable="columnArtikelcode" msprop:Generator_ColumnPropNameInTable="ArtikelcodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Barcode" msprop:Generator_UserColumnName="Barcode" msprop:Generator_ColumnPropNameInRow="Barcode" msprop:Generator_ColumnVarNameInTable="columnBarcode" msprop:Generator_ColumnPropNameInTable="BarcodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Verkoopbaar" msprop:Generator_UserColumnName="Verkoopbaar" msprop:Generator_ColumnPropNameInRow="Verkoopbaar" msprop:Generator_ColumnVarNameInTable="columnVerkoopbaar" msprop:Generator_ColumnPropNameInTable="VerkoopbaarColumn" type="xs:boolean" default="false" minOccurs="0" />
              <xs:element name="Voorraad" msprop:Generator_UserColumnName="Voorraad" msprop:Generator_ColumnPropNameInRow="Voorraad" msprop:Generator_ColumnVarNameInTable="columnVoorraad" msprop:Generator_ColumnPropNameInTable="VoorraadColumn" type="xs:int" default="0" minOccurs="0" />
              <xs:element name="AantalPerVerpakking" msprop:Generator_UserColumnName="AantalPerVerpakking" msprop:Generator_ColumnPropNameInRow="AantalPerVerpakking" msprop:Generator_ColumnVarNameInTable="columnAantalPerVerpakking" msprop:Generator_ColumnPropNameInTable="AantalPerVerpakkingColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Prijs" msprop:Generator_UserColumnName="Prijs" msprop:Generator_ColumnPropNameInRow="Prijs" msprop:Generator_ColumnVarNameInTable="columnPrijs" msprop:Generator_ColumnPropNameInTable="PrijsColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="StatiegeldEuro" msprop:Generator_UserColumnName="StatiegeldEuro" msprop:Generator_ColumnPropNameInRow="StatiegeldEuro" msprop:Generator_ColumnVarNameInTable="columnStatiegeldEuro" msprop:Generator_ColumnPropNameInTable="StatiegeldEuroColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Inkoopprijs" msprop:Generator_UserColumnName="Inkoopprijs" msprop:Generator_ColumnPropNameInRow="Inkoopprijs" msprop:Generator_ColumnVarNameInTable="columnInkoopprijs" msprop:Generator_ColumnPropNameInTable="InkoopprijsColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="BTW" msprop:Generator_UserColumnName="BTW" msprop:Generator_ColumnPropNameInRow="BTW" msprop:Generator_ColumnVarNameInTable="columnBTW" msprop:Generator_ColumnPropNameInTable="BTWColumn" type="xs:float" default="0" minOccurs="0" />
              <xs:element name="IdLeverancier" msprop:Generator_UserColumnName="IdLeverancier" msprop:Generator_ColumnPropNameInRow="IdLeverancier" msprop:Generator_ColumnVarNameInTable="columnIdLeverancier" msprop:Generator_ColumnPropNameInTable="IdLeverancierColumn" type="xs:int" default="1" minOccurs="0" />
              <xs:element name="IsLeeggoed" msprop:Generator_UserColumnName="IsLeeggoed" msprop:Generator_ColumnPropNameInRow="IsLeeggoed" msprop:Generator_ColumnVarNameInTable="columnIsLeeggoed" msprop:Generator_ColumnPropNameInTable="IsLeeggoedColumn" type="xs:boolean" default="false" minOccurs="0" />
              <xs:element name="IsCheque" msprop:Generator_UserColumnName="IsCheque" msprop:Generator_ColumnPropNameInRow="IsCheque" msprop:Generator_ColumnVarNameInTable="columnIsCheque" msprop:Generator_ColumnPropNameInTable="IsChequeColumn" type="xs:boolean" default="false" minOccurs="0" />
              <xs:element name="IdCategorie" msprop:Generator_UserColumnName="IdCategorie" msprop:Generator_ColumnVarNameInTable="columnIdCategorie" msprop:Generator_ColumnPropNameInRow="IdCategorie" msprop:Generator_ColumnPropNameInTable="IdCategorieColumn" type="xs:int" default="1" minOccurs="0" />
              <xs:element name="VerwachteVoorraad" msdata:Caption="Verwachte voorraad" msprop:Generator_UserColumnName="VerwachteVoorraad" msprop:Generator_ColumnPropNameInRow="VerwachteVoorraad" msprop:Generator_ColumnVarNameInTable="columnVerwachteVoorraad" msprop:Generator_ColumnPropNameInTable="VerwachteVoorraadColumn" type="xs:int" default="0" minOccurs="0" />
              <xs:element name="KortingLeverancier" msprop:Generator_UserColumnName="KortingLeverancier" msprop:Generator_ColumnVarNameInTable="columnKortingLeverancier" msprop:Generator_ColumnPropNameInRow="KortingLeverancier" msprop:Generator_ColumnPropNameInTable="KortingLeverancierColumn" type="xs:float" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Leveranciers" msprop:Generator_UserTableName="Leveranciers" msprop:Generator_RowDeletedName="LeveranciersRowDeleted" msprop:Generator_RowChangedName="LeveranciersRowChanged" msprop:Generator_RowClassName="LeveranciersRow" msprop:Generator_RowChangingName="LeveranciersRowChanging" msprop:Generator_RowEvArgName="LeveranciersRowChangeEvent" msprop:Generator_RowEvHandlerName="LeveranciersRowChangeEventHandler" msprop:Generator_TableClassName="LeveranciersDataTable" msprop:Generator_TableVarName="tableLeveranciers" msprop:Generator_RowDeletingName="LeveranciersRowDeleting" msprop:Generator_TablePropName="Leveranciers">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Naam" msprop:Generator_UserColumnName="Naam" msprop:Generator_ColumnPropNameInRow="Naam" msprop:Generator_ColumnVarNameInTable="columnNaam" msprop:Generator_ColumnPropNameInTable="NaamColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Categorieen" msprop:Generator_UserTableName="Categorieen" msprop:Generator_RowDeletedName="CategorieenRowDeleted" msprop:Generator_RowChangedName="CategorieenRowChanged" msprop:Generator_RowClassName="CategorieenRow" msprop:Generator_RowChangingName="CategorieenRowChanging" msprop:Generator_RowEvArgName="CategorieenRowChangeEvent" msprop:Generator_RowEvHandlerName="CategorieenRowChangeEventHandler" msprop:Generator_TableClassName="CategorieenDataTable" msprop:Generator_TableVarName="tableCategorieen" msprop:Generator_RowDeletingName="CategorieenRowDeleting" msprop:Generator_TablePropName="Categorieen">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="CategorieEnSubcategorie" msdata:ReadOnly="true" msprop:Generator_UserColumnName="CategorieEnSubcategorie" msprop:Generator_ColumnPropNameInRow="CategorieEnSubcategorie" msprop:Generator_ColumnVarNameInTable="columnCategorieEnSubcategorie" msprop:Generator_ColumnPropNameInTable="CategorieEnSubcategorieColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Categorie" msprop:Generator_UserColumnName="Categorie" msprop:Generator_ColumnPropNameInRow="Categorie" msprop:Generator_ColumnVarNameInTable="columnCategorie" msprop:Generator_ColumnPropNameInTable="CategorieColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Subcategorie" msprop:Generator_UserColumnName="Subcategorie" msprop:Generator_ColumnPropNameInRow="Subcategorie" msprop:Generator_ColumnVarNameInTable="columnSubcategorie" msprop:Generator_ColumnPropNameInTable="SubcategorieColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Leveringen" msprop:Generator_UserTableName="Leveringen" msprop:Generator_RowDeletedName="LeveringenRowDeleted" msprop:Generator_RowChangedName="LeveringenRowChanged" msprop:Generator_RowClassName="LeveringenRow" msprop:Generator_RowChangingName="LeveringenRowChanging" msprop:Generator_RowEvArgName="LeveringenRowChangeEvent" msprop:Generator_RowEvHandlerName="LeveringenRowChangeEventHandler" msprop:Generator_TableClassName="LeveringenDataTable" msprop:Generator_TableVarName="tableLeveringen" msprop:Generator_RowDeletingName="LeveringenRowDeleting" msprop:Generator_TablePropName="Leveringen">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Datum" msprop:Generator_UserColumnName="Datum" msprop:Generator_ColumnPropNameInRow="Datum" msprop:Generator_ColumnVarNameInTable="columnDatum" msprop:Generator_ColumnPropNameInTable="DatumColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IdLeverancier" msprop:Generator_UserColumnName="IdLeverancier" msprop:Generator_ColumnPropNameInRow="IdLeverancier" msprop:Generator_ColumnVarNameInTable="columnIdLeverancier" msprop:Generator_ColumnPropNameInTable="IdLeverancierColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Factuurnummer" msprop:Generator_UserColumnName="Factuurnummer" msprop:Generator_ColumnPropNameInRow="Factuurnummer" msprop:Generator_ColumnVarNameInTable="columnFactuurnummer" msprop:Generator_ColumnPropNameInTable="FactuurnummerColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="LeveringDetails" msprop:Generator_UserTableName="LeveringDetails" msprop:Generator_RowDeletedName="LeveringDetailsRowDeleted" msprop:Generator_RowChangedName="LeveringDetailsRowChanged" msprop:Generator_RowClassName="LeveringDetailsRow" msprop:Generator_RowChangingName="LeveringDetailsRowChanging" msprop:Generator_RowEvArgName="LeveringDetailsRowChangeEvent" msprop:Generator_RowEvHandlerName="LeveringDetailsRowChangeEventHandler" msprop:Generator_TableClassName="LeveringDetailsDataTable" msprop:Generator_TableVarName="tableLeveringDetails" msprop:Generator_RowDeletingName="LeveringDetailsRowDeleting" msprop:Generator_TablePropName="LeveringDetails">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="IdLevering" msprop:Generator_UserColumnName="IdLevering" msprop:Generator_ColumnPropNameInRow="IdLevering" msprop:Generator_ColumnVarNameInTable="columnIdLevering" msprop:Generator_ColumnPropNameInTable="IdLeveringColumn" type="xs:int" minOccurs="0" />
              <xs:element name="IdArtikel" msprop:Generator_UserColumnName="IdArtikel" msprop:Generator_ColumnPropNameInRow="IdArtikel" msprop:Generator_ColumnVarNameInTable="columnIdArtikel" msprop:Generator_ColumnPropNameInTable="IdArtikelColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Aantal" msprop:Generator_UserColumnName="Aantal" msprop:Generator_ColumnPropNameInRow="Aantal" msprop:Generator_ColumnVarNameInTable="columnAantal" msprop:Generator_ColumnPropNameInTable="AantalColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Korting" msprop:Generator_UserColumnName="Korting" msprop:Generator_ColumnVarNameInTable="columnKorting" msprop:Generator_ColumnPropNameInRow="Korting" msprop:Generator_ColumnPropNameInTable="KortingColumn" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Verkopen" msprop:Generator_UserTableName="Verkopen" msprop:Generator_RowDeletedName="VerkopenRowDeleted" msprop:Generator_RowChangedName="VerkopenRowChanged" msprop:Generator_RowClassName="VerkopenRow" msprop:Generator_RowChangingName="VerkopenRowChanging" msprop:Generator_RowEvArgName="VerkopenRowChangeEvent" msprop:Generator_RowEvHandlerName="VerkopenRowChangeEventHandler" msprop:Generator_TableClassName="VerkopenDataTable" msprop:Generator_TableVarName="tableVerkopen" msprop:Generator_RowDeletingName="VerkopenRowDeleting" msprop:Generator_TablePropName="Verkopen">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="IdKlant" msprop:Generator_UserColumnName="IdKlant" msprop:Generator_ColumnVarNameInTable="columnIdKlant" msprop:Generator_ColumnPropNameInRow="IdKlant" msprop:Generator_ColumnPropNameInTable="IdKlantColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CashBetaald" msprop:Generator_UserColumnName="CashBetaald" msprop:Generator_ColumnVarNameInTable="columnCashBetaald" msprop:Generator_ColumnPropNameInRow="CashBetaald" msprop:Generator_ColumnPropNameInTable="CashBetaaldColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="IdWinkelier" msprop:Generator_UserColumnName="IdWinkelier" msprop:Generator_ColumnVarNameInTable="columnIdWinkelier" msprop:Generator_ColumnPropNameInRow="IdWinkelier" msprop:Generator_ColumnPropNameInTable="IdWinkelierColumn" type="xs:int" minOccurs="0" />
              <xs:element name="IdSoort" msprop:Generator_UserColumnName="IdSoort" msprop:Generator_ColumnVarNameInTable="columnIdSoort" msprop:Generator_ColumnPropNameInRow="IdSoort" msprop:Generator_ColumnPropNameInTable="IdSoortColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Datum" msprop:Generator_UserColumnName="Datum" msprop:Generator_ColumnVarNameInTable="columnDatum" msprop:Generator_ColumnPropNameInRow="Datum" msprop:Generator_ColumnPropNameInTable="DatumColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Tijd" msprop:Generator_UserColumnName="Tijd" msprop:Generator_ColumnVarNameInTable="columnTijd" msprop:Generator_ColumnPropNameInRow="Tijd" msprop:Generator_ColumnPropNameInTable="TijdColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Begintotaal" msprop:Generator_UserColumnName="Begintotaal" msprop:Generator_ColumnVarNameInTable="columnBegintotaal" msprop:Generator_ColumnPropNameInRow="Begintotaal" msprop:Generator_ColumnPropNameInTable="BegintotaalColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="Eindtotaal" msprop:Generator_UserColumnName="Eindtotaal" msprop:Generator_ColumnVarNameInTable="columnEindtotaal" msprop:Generator_ColumnPropNameInRow="Eindtotaal" msprop:Generator_ColumnPropNameInTable="EindtotaalColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="CommentaarBegintotaal" msprop:Generator_UserColumnName="CommentaarBegintotaal" msprop:Generator_ColumnPropNameInRow="CommentaarBegintotaal" msprop:Generator_ColumnVarNameInTable="columnCommentaarBegintotaal" msprop:Generator_ColumnPropNameInTable="CommentaarBegintotaalColumn" type="xs:string" minOccurs="0" />
              <xs:element name="CommentaarEindtotaal" msprop:Generator_UserColumnName="CommentaarEindtotaal" msprop:Generator_ColumnPropNameInRow="CommentaarEindtotaal" msprop:Generator_ColumnVarNameInTable="columnCommentaarEindtotaal" msprop:Generator_ColumnPropNameInTable="CommentaarEindtotaalColumn" type="xs:string" minOccurs="0" />
              <xs:element name="InUitKasBedrag" msprop:Generator_UserColumnName="InUitKasBedrag" msprop:Generator_ColumnVarNameInTable="columnInUitKasBedrag" msprop:Generator_ColumnPropNameInRow="InUitKasBedrag" msprop:Generator_ColumnPropNameInTable="InUitKasBedragColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="InUitKasReden" msprop:Generator_UserColumnName="InUitKasReden" msprop:Generator_ColumnVarNameInTable="columnInUitKasReden" msprop:Generator_ColumnPropNameInRow="InUitKasReden" msprop:Generator_ColumnPropNameInTable="InUitKasRedenColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NaarBankBedrag" msprop:Generator_UserColumnName="NaarBankBedrag" msprop:Generator_ColumnVarNameInTable="columnNaarBankBedrag" msprop:Generator_ColumnPropNameInRow="NaarBankBedrag" msprop:Generator_ColumnPropNameInTable="NaarBankBedragColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="NaarBankNaam" msprop:Generator_UserColumnName="NaarBankNaam" msprop:Generator_ColumnPropNameInRow="NaarBankNaam" msprop:Generator_ColumnVarNameInTable="columnNaarBankNaam" msprop:Generator_ColumnPropNameInTable="NaarBankNaamColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NaarBankReferentie" msprop:Generator_UserColumnName="NaarBankReferentie" msprop:nullValue="_throw" msprop:Generator_ColumnVarNameInTable="columnNaarBankReferentie" msprop:Generator_ColumnPropNameInTable="NaarBankReferentieColumn" msprop:Generator_ColumnPropNameInRow="NaarBankReferentie" default="" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FactuurNummer" msprop:Generator_UserColumnName="FactuurNummer" msprop:Generator_ColumnPropNameInRow="FactuurNummer" msprop:Generator_ColumnVarNameInTable="columnFactuurNummer" msprop:Generator_ColumnPropNameInTable="FactuurNummerColumn" type="xs:int" minOccurs="0" />
              <xs:element name="IsFactuurBehandeld" msprop:Generator_UserColumnName="IsFactuurBehandeld" msprop:Generator_ColumnPropNameInRow="IsFactuurBehandeld" msprop:Generator_ColumnVarNameInTable="columnIsFactuurBehandeld" msprop:Generator_ColumnPropNameInTable="IsFactuurBehandeldColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Omschrijving" msprop:Generator_UserColumnName="Omschrijving" msprop:Generator_ColumnPropNameInRow="Omschrijving" msprop:Generator_ColumnVarNameInTable="columnOmschrijving" msprop:Generator_ColumnPropNameInTable="OmschrijvingColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AantalDetails" msdata:ReadOnly="true" msdata:Expression="count(Child.Id)" msprop:Generator_UserColumnName="AantalDetails" msprop:Generator_ColumnPropNameInRow="AantalDetails" msprop:Generator_ColumnVarNameInTable="columnAantalDetails" msprop:Generator_ColumnPropNameInTable="AantalDetailsColumn" type="xs:int" default="0" minOccurs="0" />
              <xs:element name="Kortingspercentage" msprop:Generator_UserColumnName="Kortingspercentage" msprop:Generator_ColumnPropNameInRow="Kortingspercentage" msprop:Generator_ColumnVarNameInTable="columnKortingspercentage" msprop:Generator_ColumnPropNameInTable="KortingspercentageColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="Consignatie" msprop:Generator_UserColumnName="Consignatie" msprop:Generator_ColumnVarNameInTable="columnConsignatie" msprop:Generator_ColumnPropNameInRow="Consignatie" msprop:Generator_ColumnPropNameInTable="ConsignatieColumn" type="xs:boolean" default="false" minOccurs="0" />
              <xs:element name="BedragBancontact" msprop:Generator_UserColumnName="BedragBancontact" msprop:Generator_ColumnPropNameInRow="BedragBancontact" msprop:Generator_ColumnVarNameInTable="columnBedragBancontact" msprop:Generator_ColumnPropNameInTable="BedragBancontactColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="BedragMaaltijdcheques" msprop:Generator_UserColumnName="BedragMaaltijdcheques" msprop:Generator_ColumnPropNameInRow="BedragMaaltijdcheques" msprop:Generator_ColumnVarNameInTable="columnBedragMaaltijdcheques" msprop:Generator_ColumnPropNameInTable="BedragMaaltijdchequesColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="VerkoopsDetails" msprop:Generator_UserTableName="VerkoopsDetails" msprop:Generator_RowDeletedName="VerkoopsDetailsRowDeleted" msprop:Generator_RowChangedName="VerkoopsDetailsRowChanged" msprop:Generator_RowClassName="VerkoopsDetailsRow" msprop:Generator_RowChangingName="VerkoopsDetailsRowChanging" msprop:Generator_RowEvArgName="VerkoopsDetailsRowChangeEvent" msprop:Generator_RowEvHandlerName="VerkoopsDetailsRowChangeEventHandler" msprop:Generator_TableClassName="VerkoopsDetailsDataTable" msprop:Generator_TableVarName="tableVerkoopsDetails" msprop:Generator_RowDeletingName="VerkoopsDetailsRowDeleting" msprop:Generator_TablePropName="VerkoopsDetails">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="IdVerkoop" msprop:Generator_UserColumnName="IdVerkoop" msprop:Generator_ColumnVarNameInTable="columnIdVerkoop" msprop:Generator_ColumnPropNameInRow="IdVerkoop" msprop:Generator_ColumnPropNameInTable="IdVerkoopColumn" type="xs:int" minOccurs="0" />
              <xs:element name="VolgnummerKlant" msprop:Generator_UserColumnName="VolgnummerKlant" msprop:Generator_ColumnVarNameInTable="columnVolgnummerKlant" msprop:Generator_ColumnPropNameInRow="VolgnummerKlant" msprop:Generator_ColumnPropNameInTable="VolgnummerKlantColumn" type="xs:int" minOccurs="0" />
              <xs:element name="IdArtikel" msprop:Generator_UserColumnName="IdArtikel" msprop:Generator_ColumnVarNameInTable="columnIdArtikel" msprop:Generator_ColumnPropNameInRow="IdArtikel" msprop:Generator_ColumnPropNameInTable="IdArtikelColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Prijs" msprop:Generator_UserColumnName="Prijs" msprop:Generator_ColumnVarNameInTable="columnPrijs" msprop:Generator_ColumnPropNameInRow="Prijs" msprop:Generator_ColumnPropNameInTable="PrijsColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="Aantal" msprop:Generator_UserColumnName="Aantal" msprop:Generator_ColumnVarNameInTable="columnAantal" msprop:Generator_ColumnPropNameInRow="Aantal" msprop:Generator_ColumnPropNameInTable="AantalColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Omschrijving" msprop:Generator_UserColumnName="Omschrijving" msprop:Generator_ColumnPropNameInRow="Omschrijving" msprop:Generator_ColumnVarNameInTable="columnOmschrijving" msprop:Generator_ColumnPropNameInTable="OmschrijvingColumn" type="xs:string" minOccurs="0" />
              <xs:element name="Barcode" msprop:Generator_UserColumnName="Barcode" msprop:Generator_ColumnPropNameInRow="Barcode" msprop:Generator_ColumnVarNameInTable="columnBarcode" msprop:Generator_ColumnPropNameInTable="BarcodeColumn" type="xs:string" minOccurs="0" />
              <xs:element name="BTW" msprop:Generator_UserColumnName="BTW" msprop:Generator_ColumnPropNameInRow="BTW" msprop:Generator_ColumnVarNameInTable="columnBTW" msprop:Generator_ColumnPropNameInTable="BTWColumn" type="xs:float" default="0" minOccurs="0" />
              <xs:element name="Totaal" msprop:Generator_UserColumnName="Totaal" msprop:Generator_ColumnVarNameInTable="columnTotaal" msprop:Generator_ColumnPropNameInRow="Totaal" msprop:Generator_ColumnPropNameInTable="TotaalColumn" type="xs:decimal" default="0" minOccurs="0" />
              <xs:element name="StatiegeldEuro" msprop:Generator_UserColumnName="StatiegeldEuro" msprop:Generator_ColumnVarNameInTable="columnStatiegeldEuro" msprop:Generator_ColumnPropNameInRow="StatiegeldEuro" msprop:Generator_ColumnPropNameInTable="StatiegeldEuroColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="TotaalStatiegeld" msdata:ReadOnly="true" msdata:Expression="StatiegeldEuro*Aantal" msprop:Generator_UserColumnName="TotaalStatiegeld" msprop:Generator_ColumnVarNameInTable="columnTotaalStatiegeld" msprop:Generator_ColumnPropNameInRow="TotaalStatiegeld" msprop:Generator_ColumnPropNameInTable="TotaalStatiegeldColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" type="xs:int" default="0" />
              <xs:element name="ExtraOmschrijving" msprop:Generator_UserColumnName="ExtraOmschrijving" msprop:Generator_ColumnPropNameInRow="ExtraOmschrijving" msprop:Generator_ColumnVarNameInTable="columnExtraOmschrijving" msprop:Generator_ColumnPropNameInTable="ExtraOmschrijvingColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bancontact" msprop:Generator_UserColumnName="Bancontact" msprop:Generator_ColumnPropNameInRow="Bancontact" msprop:Generator_ColumnVarNameInTable="columnBancontact" msprop:Generator_ColumnPropNameInTable="BancontactColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Maaltijdcheque" msprop:Generator_UserColumnName="Maaltijdcheque" msprop:Generator_ColumnPropNameInRow="Maaltijdcheque" msprop:Generator_ColumnVarNameInTable="columnMaaltijdcheque" msprop:Generator_ColumnPropNameInTable="MaaltijdchequeColumn" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Klanten" msprop:Generator_UserTableName="Klanten" msprop:Generator_RowDeletedName="KlantenRowDeleted" msprop:Generator_RowChangedName="KlantenRowChanged" msprop:Generator_RowClassName="KlantenRow" msprop:Generator_RowChangingName="KlantenRowChanging" msprop:Generator_RowEvArgName="KlantenRowChangeEvent" msprop:Generator_RowEvHandlerName="KlantenRowChangeEventHandler" msprop:Generator_TableClassName="KlantenDataTable" msprop:Generator_TableVarName="tableKlanten" msprop:Generator_RowDeletingName="KlantenRowDeleting" msprop:Generator_TablePropName="Klanten">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Naam" msprop:Generator_UserColumnName="Naam" msprop:Generator_ColumnVarNameInTable="columnNaam" msprop:Generator_ColumnPropNameInRow="Naam" msprop:Generator_ColumnPropNameInTable="NaamColumn" default="" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Adres" msprop:Generator_UserColumnName="Adres" msprop:Generator_ColumnVarNameInTable="columnAdres" msprop:Generator_ColumnPropNameInRow="Adres" msprop:Generator_ColumnPropNameInTable="AdresColumn" default="" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Postcode" msprop:Generator_UserColumnName="Postcode" msprop:Generator_ColumnVarNameInTable="columnPostcode" msprop:Generator_ColumnPropNameInRow="Postcode" msprop:Generator_ColumnPropNameInTable="PostcodeColumn" default="" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Gemeente" msprop:Generator_UserColumnName="Gemeente" msprop:Generator_ColumnVarNameInTable="columnGemeente" msprop:Generator_ColumnPropNameInRow="Gemeente" msprop:Generator_ColumnPropNameInTable="GemeenteColumn" default="" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Telefoon" msprop:Generator_UserColumnName="Telefoon" msprop:Generator_ColumnVarNameInTable="columnTelefoon" msprop:Generator_ColumnPropNameInRow="Telefoon" msprop:Generator_ColumnPropNameInTable="TelefoonColumn" default="" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" default="" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Klantenkaart" msprop:Generator_UserColumnName="Klantenkaart" msprop:Generator_ColumnVarNameInTable="columnKlantenkaart" msprop:Generator_ColumnPropNameInRow="Klantenkaart" msprop:Generator_ColumnPropNameInTable="KlantenkaartColumn" type="xs:boolean" default="false" minOccurs="0" />
              <xs:element name="Fax" msprop:Generator_UserColumnName="Fax" msprop:Generator_ColumnPropNameInRow="Fax" msprop:Generator_ColumnVarNameInTable="columnFax" msprop:Generator_ColumnPropNameInTable="FaxColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GSM" msprop:Generator_UserColumnName="GSM" msprop:Generator_ColumnPropNameInRow="GSM" msprop:Generator_ColumnVarNameInTable="columnGSM" msprop:Generator_ColumnPropNameInTable="GSMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContactPersoon" msprop:Generator_UserColumnName="ContactPersoon" msprop:Generator_ColumnPropNameInRow="ContactPersoon" msprop:Generator_ColumnVarNameInTable="columnContactPersoon" msprop:Generator_ColumnPropNameInTable="ContactPersoonColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TerAttentieVan" msprop:Generator_UserColumnName="TerAttentieVan" msprop:Generator_ColumnPropNameInRow="TerAttentieVan" msprop:Generator_ColumnVarNameInTable="columnTerAttentieVan" msprop:Generator_ColumnPropNameInTable="TerAttentieVanColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KortingsPercentage" msprop:Generator_UserColumnName="KortingsPercentage" msprop:Generator_ColumnPropNameInRow="KortingsPercentage" msprop:Generator_ColumnVarNameInTable="columnKortingsPercentage" msprop:Generator_ColumnPropNameInTable="KortingsPercentageColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="BetaalConditieCode" msprop:Generator_UserColumnName="BetaalConditieCode" msprop:Generator_ColumnPropNameInRow="BetaalConditieCode" msprop:Generator_ColumnVarNameInTable="columnBetaalConditieCode" msprop:Generator_ColumnPropNameInTable="BetaalConditieCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DatumVanVerwerking" msprop:Generator_UserColumnName="DatumVanVerwerking" msprop:Generator_ColumnPropNameInRow="DatumVanVerwerking" msprop:Generator_ColumnVarNameInTable="columnDatumVanVerwerking" msprop:Generator_ColumnPropNameInTable="DatumVanVerwerkingColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NaamEnGemeente" msdata:ReadOnly="true" msdata:Expression="Naam + ' (' + Gemeente + ')'" msprop:Generator_UserColumnName="NaamEnGemeente" msprop:Generator_ColumnVarNameInTable="columnNaamEnGemeente" msprop:Generator_ColumnPropNameInRow="NaamEnGemeente" msprop:Generator_ColumnPropNameInTable="NaamEnGemeenteColumn" type="xs:string" minOccurs="0" />
              <xs:element name="BTWnummer" msprop:Generator_UserColumnName="BTWnummer" msprop:Generator_ColumnPropNameInRow="BTWnummer" msprop:Generator_ColumnVarNameInTable="columnBTWnummer" msprop:Generator_ColumnPropNameInTable="BTWnummerColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Winkeliers" msprop:Generator_UserTableName="Winkeliers" msprop:Generator_RowDeletedName="WinkeliersRowDeleted" msprop:Generator_RowChangedName="WinkeliersRowChanged" msprop:Generator_RowClassName="WinkeliersRow" msprop:Generator_RowChangingName="WinkeliersRowChanging" msprop:Generator_RowEvArgName="WinkeliersRowChangeEvent" msprop:Generator_RowEvHandlerName="WinkeliersRowChangeEventHandler" msprop:Generator_TableClassName="WinkeliersDataTable" msprop:Generator_TableVarName="tableWinkeliers" msprop:Generator_RowDeletingName="WinkeliersRowDeleting" msprop:Generator_TablePropName="Winkeliers">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Naam" msprop:Generator_UserColumnName="Naam" msprop:Generator_ColumnPropNameInRow="Naam" msprop:Generator_ColumnVarNameInTable="columnNaam" msprop:Generator_ColumnPropNameInTable="NaamColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Wachtwoord" msprop:Generator_UserColumnName="Wachtwoord" msprop:Generator_ColumnPropNameInRow="Wachtwoord" msprop:Generator_ColumnVarNameInTable="columnWachtwoord" msprop:Generator_ColumnPropNameInTable="WachtwoordColumn" default="" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdLaatsteMelding" msprop:Generator_UserColumnName="IdLaatsteMelding" msprop:Generator_ColumnPropNameInRow="IdLaatsteMelding" msprop:Generator_ColumnVarNameInTable="columnIdLaatsteMelding" msprop:Generator_ColumnPropNameInTable="IdLaatsteMeldingColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Verkoopsoorten" msprop:Generator_UserTableName="Verkoopsoorten" msprop:Generator_RowDeletedName="VerkoopsoortenRowDeleted" msprop:Generator_RowChangedName="VerkoopsoortenRowChanged" msprop:Generator_RowClassName="VerkoopsoortenRow" msprop:Generator_RowChangingName="VerkoopsoortenRowChanging" msprop:Generator_RowEvArgName="VerkoopsoortenRowChangeEvent" msprop:Generator_RowEvHandlerName="VerkoopsoortenRowChangeEventHandler" msprop:Generator_TableClassName="VerkoopsoortenDataTable" msprop:Generator_TableVarName="tableVerkoopsoorten" msprop:Generator_RowDeletingName="VerkoopsoortenRowDeleting" msprop:Generator_TablePropName="Verkoopsoorten">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Omschrijving" msprop:Generator_UserColumnName="Omschrijving" msprop:Generator_ColumnVarNameInTable="columnOmschrijving" msprop:Generator_ColumnPropNameInRow="Omschrijving" msprop:Generator_ColumnPropNameInTable="OmschrijvingColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Voorraadbewegingen" msprop:Generator_UserTableName="Voorraadbewegingen" msprop:Generator_RowDeletedName="VoorraadbewegingenRowDeleted" msprop:Generator_RowChangedName="VoorraadbewegingenRowChanged" msprop:Generator_RowClassName="VoorraadbewegingenRow" msprop:Generator_RowChangingName="VoorraadbewegingenRowChanging" msprop:Generator_RowEvArgName="VoorraadbewegingenRowChangeEvent" msprop:Generator_RowEvHandlerName="VoorraadbewegingenRowChangeEventHandler" msprop:Generator_TableClassName="VoorraadbewegingenDataTable" msprop:Generator_TableVarName="tableVoorraadbewegingen" msprop:Generator_RowDeletingName="VoorraadbewegingenRowDeleting" msprop:Generator_TablePropName="Voorraadbewegingen">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="IdArtikel" msprop:Generator_UserColumnName="IdArtikel" msprop:Generator_ColumnPropNameInRow="IdArtikel" msprop:Generator_ColumnVarNameInTable="columnIdArtikel" msprop:Generator_ColumnPropNameInTable="IdArtikelColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Datum" msprop:Generator_UserColumnName="Datum" msprop:Generator_ColumnPropNameInRow="Datum" msprop:Generator_ColumnVarNameInTable="columnDatum" msprop:Generator_ColumnPropNameInTable="DatumColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Aantal" msprop:Generator_UserColumnName="Aantal" msprop:Generator_ColumnPropNameInRow="Aantal" msprop:Generator_ColumnVarNameInTable="columnAantal" msprop:Generator_ColumnPropNameInTable="AantalColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Reden" msprop:Generator_UserColumnName="Reden" msprop:Generator_ColumnPropNameInRow="Reden" msprop:Generator_ColumnVarNameInTable="columnReden" msprop:Generator_ColumnPropNameInTable="RedenColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Artikel" msprop:Generator_UserColumnName="Artikel" msprop:Generator_ColumnPropNameInRow="Artikel" msprop:Generator_ColumnVarNameInTable="columnArtikel" msprop:Generator_ColumnPropNameInTable="ArtikelColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Inkoopprijs" msprop:Generator_UserColumnName="Inkoopprijs" msprop:Generator_ColumnVarNameInTable="columnInkoopprijs" msprop:Generator_ColumnPropNameInRow="Inkoopprijs" msprop:Generator_ColumnPropNameInTable="InkoopprijsColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Meldingen" msprop:Generator_UserTableName="Meldingen" msprop:Generator_RowDeletedName="MeldingenRowDeleted" msprop:Generator_RowChangedName="MeldingenRowChanged" msprop:Generator_RowClassName="MeldingenRow" msprop:Generator_RowChangingName="MeldingenRowChanging" msprop:Generator_RowEvArgName="MeldingenRowChangeEvent" msprop:Generator_RowEvHandlerName="MeldingenRowChangeEventHandler" msprop:Generator_TableClassName="MeldingenDataTable" msprop:Generator_TableVarName="tableMeldingen" msprop:Generator_RowDeletingName="MeldingenRowDeleting" msprop:Generator_TablePropName="Meldingen">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Melding" msprop:Generator_UserColumnName="Melding" msprop:Generator_ColumnPropNameInRow="Melding" msprop:Generator_ColumnVarNameInTable="columnMelding" msprop:Generator_ColumnPropNameInTable="MeldingColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Artikels" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Leveranciers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Leveranciers" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Categorieen_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Categorieen" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Leveringen_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Leveringen" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="LeveringDetails_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:LeveringDetails" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Verkopen_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Verkopen" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="VerkoopsDetails_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:VerkoopsDetails" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Klanten_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Klanten" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Winkeliers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Winkeliers" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Verkoopsoorten_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Verkoopsoorten" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Voorraadbewegingen_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Voorraadbewegingen" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Meldingen_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Meldingen" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="LeveranciersArtikels" msdata:parent="Leveranciers" msdata:child="Artikels" msdata:parentkey="Id" msdata:childkey="IdLeverancier" msprop:Generator_UserRelationName="LeveranciersArtikels" msprop:Generator_RelationVarName="relationLeveranciersArtikels" msprop:Generator_UserChildTable="Artikels" msprop:Generator_UserParentTable="Leveranciers" msprop:Generator_ParentPropName="LeveranciersRow" msprop:Generator_ChildPropName="GetArtikelsRows" />
      <msdata:Relationship name="Reference" msdata:parent="Categorieen" msdata:child="Artikels" msdata:parentkey="Id" msdata:childkey="IdCategorie" msprop:Generator_UserRelationName="Reference" msprop:Generator_RelationVarName="relationReference" msprop:Generator_UserChildTable="Artikels" msprop:Generator_UserParentTable="Categorieen" msprop:Generator_ParentPropName="CategorieenRow" msprop:Generator_ChildPropName="GetArtikelsRows" />
      <msdata:Relationship name="LeveranciersLeveringen" msdata:parent="Leveranciers" msdata:child="Leveringen" msdata:parentkey="Id" msdata:childkey="IdLeverancier" msprop:Generator_UserRelationName="LeveranciersLeveringen" msprop:Generator_RelationVarName="relationLeveranciersLeveringen" msprop:Generator_UserChildTable="Leveringen" msprop:Generator_UserParentTable="Leveranciers" msprop:Generator_ParentPropName="LeveranciersRow" msprop:Generator_ChildPropName="GetLeveringenRows" />
      <msdata:Relationship name="_x007B_A35EB345-7215-4DC2-B69B-434472EEA6DB_x007D_" msdata:parent="Leveringen" msdata:child="LeveringDetails" msdata:parentkey="Id" msdata:childkey="IdLevering" msprop:Generator_UserRelationName="{A35EB345-7215-4DC2-B69B-434472EEA6DB}" msprop:Generator_RelationVarName="_relation_A35EB345_7215_4DC2_B69B_434472EEA6DB_" msprop:Generator_UserChildTable="LeveringDetails" msprop:Generator_UserParentTable="Leveringen" msprop:Generator_ParentPropName="LeveringenRow" msprop:Generator_ChildPropName="GetLeveringDetailsRows" />
      <msdata:Relationship name="ArtikelsLeveringDetails" msdata:parent="Artikels" msdata:child="LeveringDetails" msdata:parentkey="Id" msdata:childkey="IdArtikel" msprop:Generator_UserRelationName="ArtikelsLeveringDetails" msprop:Generator_RelationVarName="relationArtikelsLeveringDetails" msprop:Generator_UserChildTable="LeveringDetails" msprop:Generator_UserParentTable="Artikels" msprop:Generator_ParentPropName="ArtikelsRow" msprop:Generator_ChildPropName="GetLeveringDetailsRows" />
      <msdata:Relationship name="VerkopenVerkoopsDetails" msdata:parent="Verkopen" msdata:child="VerkoopsDetails" msdata:parentkey="Id" msdata:childkey="IdVerkoop" msprop:Generator_UserRelationName="VerkopenVerkoopsDetails" msprop:Generator_RelationVarName="relationVerkopenVerkoopsDetails" msprop:Generator_UserChildTable="VerkoopsDetails" msprop:Generator_UserParentTable="Verkopen" msprop:Generator_ParentPropName="VerkopenRow" msprop:Generator_ChildPropName="GetVerkoopsDetailsRows" />
      <msdata:Relationship name="Artikels_VerkoopsDetails" msdata:parent="Artikels" msdata:child="VerkoopsDetails" msdata:parentkey="Id" msdata:childkey="IdArtikel" msprop:Generator_UserRelationName="Artikels_VerkoopsDetails" msprop:Generator_RelationVarName="relationArtikels_VerkoopsDetails" msprop:Generator_UserChildTable="VerkoopsDetails" msprop:Generator_UserParentTable="Artikels" msprop:Generator_ParentPropName="ArtikelsRow" msprop:Generator_ChildPropName="GetVerkoopsDetailsRows" />
      <msdata:Relationship name="KlantenVerkopen" msdata:parent="Klanten" msdata:child="Verkopen" msdata:parentkey="Id" msdata:childkey="IdKlant" msprop:Generator_UserRelationName="KlantenVerkopen" msprop:Generator_RelationVarName="relationKlantenVerkopen" msprop:Generator_UserChildTable="Verkopen" msprop:Generator_UserParentTable="Klanten" msprop:Generator_ParentPropName="KlantenRow" msprop:Generator_ChildPropName="GetVerkopenRows" />
      <msdata:Relationship name="Winkeliers_Verkopen" msdata:parent="Winkeliers" msdata:child="Verkopen" msdata:parentkey="Id" msdata:childkey="IdWinkelier" msprop:Generator_UserRelationName="Winkeliers_Verkopen" msprop:Generator_RelationVarName="relationWinkeliers_Verkopen" msprop:Generator_UserChildTable="Verkopen" msprop:Generator_UserParentTable="Winkeliers" msprop:Generator_ParentPropName="WinkeliersRow" msprop:Generator_ChildPropName="GetVerkopenRows" />
      <msdata:Relationship name="Verkoopsoorten_Verkopen" msdata:parent="Verkoopsoorten" msdata:child="Verkopen" msdata:parentkey="Id" msdata:childkey="IdSoort" msprop:Generator_UserRelationName="Verkoopsoorten_Verkopen" msprop:Generator_RelationVarName="relationVerkoopsoorten_Verkopen" msprop:Generator_UserChildTable="Verkopen" msprop:Generator_UserParentTable="Verkoopsoorten" msprop:Generator_ParentPropName="VerkoopsoortenRow" msprop:Generator_ChildPropName="GetVerkopenRows" />
      <msdata:Relationship name="Artikels_Voorraadbewegingen" msdata:parent="Artikels" msdata:child="Voorraadbewegingen" msdata:parentkey="Id" msdata:childkey="IdArtikel" msprop:Generator_UserRelationName="Artikels_Voorraadbewegingen" msprop:Generator_RelationVarName="relationArtikels_Voorraadbewegingen" msprop:Generator_UserChildTable="Voorraadbewegingen" msprop:Generator_UserParentTable="Artikels" msprop:Generator_ParentPropName="ArtikelsRow" msprop:Generator_ChildPropName="GetVoorraadbewegingenRows" />
      <msdata:Relationship name="ArtikelsLeveringDetails1" msdata:parent="VerkoopsDetails" msdata:child="LeveringDetails" msdata:parentkey="Id" msdata:childkey="IdArtikel" msprop:Generator_UserRelationName="ArtikelsLeveringDetails1" msprop:Generator_RelationVarName="relationArtikelsLeveringDetails1" msprop:Generator_UserChildTable="LeveringDetails" msprop:Generator_UserParentTable="VerkoopsDetails" msprop:Generator_ParentPropName="VerkoopsDetailsRow" msprop:Generator_ChildPropName="GetLeveringDetailsRows" />
      <msdata:Relationship name="ArtikelsStockBewegingen" msdata:parent="VerkoopsDetails" msdata:child="Voorraadbewegingen" msdata:parentkey="Id" msdata:childkey="IdArtikel" msprop:Generator_UserRelationName="ArtikelsStockBewegingen" msprop:Generator_RelationVarName="relationArtikelsStockBewegingen" msprop:Generator_UserChildTable="Voorraadbewegingen" msprop:Generator_UserParentTable="VerkoopsDetails" msprop:Generator_ParentPropName="VerkoopsDetailsRow" msprop:Generator_ChildPropName="GetVoorraadbewegingenRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>